package cn.invest.merry.module.invest.dal.mysql.xjbase;

import java.util.*;

import cn.invest.merry.framework.common.pojo.PageResult;
import cn.invest.merry.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.invest.merry.framework.mybatis.core.mapper.BaseMapperX;
import cn.invest.merry.module.invest.dal.dataobject.xjbase.XjBaseDO;
import org.apache.ibatis.annotations.Mapper;
import cn.invest.merry.module.invest.controller.admin.xjbase.vo.*;

/**
 * 个股报告期现金 Mapper
 *
 * @author 芋道源码
 */
@Mapper
public interface XjBaseMapper extends BaseMapperX<XjBaseDO> {

    default PageResult<XjBaseDO> selectPage(XjBasePageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<XjBaseDO>()
                .likeIfPresent(XjBaseDO::getSecname, reqVO.getSecname())
                .eqIfPresent(XjBaseDO::getSeccode, reqVO.getSeccode())
                .likeIfPresent(XjBaseDO::getOrgname, reqVO.getOrgname())
                .betweenIfPresent(XjBaseDO::getDeclaredate, reqVO.getDeclaredate())
                .betweenIfPresent(XjBaseDO::getStartdate, reqVO.getStartdate())
                .betweenIfPresent(XjBaseDO::getEnddate, reqVO.getEnddate())
                .eqIfPresent(XjBaseDO::getF001d, reqVO.getF001d())
                .eqIfPresent(XjBaseDO::getF002v, reqVO.getF002v())
                .eqIfPresent(XjBaseDO::getF003v, reqVO.getF003v())
                .eqIfPresent(XjBaseDO::getF004v, reqVO.getF004v())
                .eqIfPresent(XjBaseDO::getF005v, reqVO.getF005v())
                .eqIfPresent(XjBaseDO::getF006n, reqVO.getF006n())
                .eqIfPresent(XjBaseDO::getF072n, reqVO.getF072n())
                .eqIfPresent(XjBaseDO::getF073n, reqVO.getF073n())
                .eqIfPresent(XjBaseDO::getF074n, reqVO.getF074n())
                .eqIfPresent(XjBaseDO::getF077n, reqVO.getF077n())
                .eqIfPresent(XjBaseDO::getF078n, reqVO.getF078n())
                .eqIfPresent(XjBaseDO::getF079n, reqVO.getF079n())
                .eqIfPresent(XjBaseDO::getF080n, reqVO.getF080n())
                .eqIfPresent(XjBaseDO::getF081n, reqVO.getF081n())
                .eqIfPresent(XjBaseDO::getF082n, reqVO.getF082n())
                .eqIfPresent(XjBaseDO::getF083n, reqVO.getF083n())
                .eqIfPresent(XjBaseDO::getF007n, reqVO.getF007n())
                .eqIfPresent(XjBaseDO::getF008n, reqVO.getF008n())
                .eqIfPresent(XjBaseDO::getF009n, reqVO.getF009n())
                .eqIfPresent(XjBaseDO::getF010n, reqVO.getF010n())
                .eqIfPresent(XjBaseDO::getF084n, reqVO.getF084n())
                .eqIfPresent(XjBaseDO::getF085n, reqVO.getF085n())
                .eqIfPresent(XjBaseDO::getF086n, reqVO.getF086n())
                .eqIfPresent(XjBaseDO::getF087n, reqVO.getF087n())
                .eqIfPresent(XjBaseDO::getF088n, reqVO.getF088n())
                .eqIfPresent(XjBaseDO::getF011n, reqVO.getF011n())
                .eqIfPresent(XjBaseDO::getF012n, reqVO.getF012n())
                .eqIfPresent(XjBaseDO::getF013n, reqVO.getF013n())
                .eqIfPresent(XjBaseDO::getF014n, reqVO.getF014n())
                .eqIfPresent(XjBaseDO::getF015n, reqVO.getF015n())
                .eqIfPresent(XjBaseDO::getF016n, reqVO.getF016n())
                .eqIfPresent(XjBaseDO::getF017n, reqVO.getF017n())
                .eqIfPresent(XjBaseDO::getF018n, reqVO.getF018n())
                .eqIfPresent(XjBaseDO::getF019n, reqVO.getF019n())
                .eqIfPresent(XjBaseDO::getF020n, reqVO.getF020n())
                .eqIfPresent(XjBaseDO::getF021n, reqVO.getF021n())
                .eqIfPresent(XjBaseDO::getF022n, reqVO.getF022n())
                .eqIfPresent(XjBaseDO::getF023n, reqVO.getF023n())
                .eqIfPresent(XjBaseDO::getF075n, reqVO.getF075n())
                .eqIfPresent(XjBaseDO::getF024n, reqVO.getF024n())
                .eqIfPresent(XjBaseDO::getF025n, reqVO.getF025n())
                .eqIfPresent(XjBaseDO::getF026n, reqVO.getF026n())
                .eqIfPresent(XjBaseDO::getF027n, reqVO.getF027n())
                .eqIfPresent(XjBaseDO::getF028n, reqVO.getF028n())
                .eqIfPresent(XjBaseDO::getF089n, reqVO.getF089n())
                .eqIfPresent(XjBaseDO::getF029n, reqVO.getF029n())
                .eqIfPresent(XjBaseDO::getF076n, reqVO.getF076n())
                .eqIfPresent(XjBaseDO::getF030n, reqVO.getF030n())
                .eqIfPresent(XjBaseDO::getF031n, reqVO.getF031n())
                .eqIfPresent(XjBaseDO::getF032n, reqVO.getF032n())
                .eqIfPresent(XjBaseDO::getF033n, reqVO.getF033n())
                .eqIfPresent(XjBaseDO::getF090n, reqVO.getF090n())
                .eqIfPresent(XjBaseDO::getF034n, reqVO.getF034n())
                .eqIfPresent(XjBaseDO::getF035n, reqVO.getF035n())
                .eqIfPresent(XjBaseDO::getF036n, reqVO.getF036n())
                .eqIfPresent(XjBaseDO::getF037n, reqVO.getF037n())
                .eqIfPresent(XjBaseDO::getF038n, reqVO.getF038n())
                .eqIfPresent(XjBaseDO::getF039n, reqVO.getF039n())
                .eqIfPresent(XjBaseDO::getF040n, reqVO.getF040n())
                .eqIfPresent(XjBaseDO::getF041n, reqVO.getF041n())
                .eqIfPresent(XjBaseDO::getF044n, reqVO.getF044n())
                .eqIfPresent(XjBaseDO::getF045n, reqVO.getF045n())
                .eqIfPresent(XjBaseDO::getF046n, reqVO.getF046n())
                .eqIfPresent(XjBaseDO::getF091n, reqVO.getF091n())
                .eqIfPresent(XjBaseDO::getF047n, reqVO.getF047n())
                .eqIfPresent(XjBaseDO::getF048n, reqVO.getF048n())
                .eqIfPresent(XjBaseDO::getF049n, reqVO.getF049n())
                .eqIfPresent(XjBaseDO::getF050n, reqVO.getF050n())
                .eqIfPresent(XjBaseDO::getF051n, reqVO.getF051n())
                .eqIfPresent(XjBaseDO::getF052n, reqVO.getF052n())
                .eqIfPresent(XjBaseDO::getF053n, reqVO.getF053n())
                .eqIfPresent(XjBaseDO::getF054n, reqVO.getF054n())
                .eqIfPresent(XjBaseDO::getF055n, reqVO.getF055n())
                .eqIfPresent(XjBaseDO::getF056n, reqVO.getF056n())
                .eqIfPresent(XjBaseDO::getF057n, reqVO.getF057n())
                .eqIfPresent(XjBaseDO::getF058n, reqVO.getF058n())
                .eqIfPresent(XjBaseDO::getF059n, reqVO.getF059n())
                .eqIfPresent(XjBaseDO::getF060n, reqVO.getF060n())
                .eqIfPresent(XjBaseDO::getF062n, reqVO.getF062n())
                .eqIfPresent(XjBaseDO::getF063n, reqVO.getF063n())
                .eqIfPresent(XjBaseDO::getF064n, reqVO.getF064n())
                .eqIfPresent(XjBaseDO::getF066n, reqVO.getF066n())
                .eqIfPresent(XjBaseDO::getF067n, reqVO.getF067n())
                .eqIfPresent(XjBaseDO::getF068n, reqVO.getF068n())
                .eqIfPresent(XjBaseDO::getF069n, reqVO.getF069n())
                .eqIfPresent(XjBaseDO::getF070n, reqVO.getF070n())
                .eqIfPresent(XjBaseDO::getF071n, reqVO.getF071n())
                .eqIfPresent(XjBaseDO::getF096n, reqVO.getF096n())
                .eqIfPresent(XjBaseDO::getF099n, reqVO.getF099n())
                .eqIfPresent(XjBaseDO::getF100n, reqVO.getF100n())
                .eqIfPresent(XjBaseDO::getF101n, reqVO.getF101n())
                .eqIfPresent(XjBaseDO::getF102n, reqVO.getF102n())
                .eqIfPresent(XjBaseDO::getF103n, reqVO.getF103n())
                .eqIfPresent(XjBaseDO::getF104n, reqVO.getF104n())
                .eqIfPresent(XjBaseDO::getF105n, reqVO.getF105n())
                .eqIfPresent(XjBaseDO::getF106n, reqVO.getF106n())
                .eqIfPresent(XjBaseDO::getF107n, reqVO.getF107n())
                .betweenIfPresent(XjBaseDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(XjBaseDO::getId));
    }

}